SUPPORT / SAMPLES & SAS NOTES
Installation Note 37713: Following SAS® Performance Management Solutions migration to 5.1 release, some SAS Data Integration Studio jobs miss values for "Load Time Column"
 |  |  |  |  |
Following the migration of a SAS Performance Management Solution (SAS Financial Management, SAS Human Capital Management, SAS Strategy Management/SAS Strategic Performance Management) to release 5.1, some SAS Data Integration Studio jobs might be missing values for the "Load Time Column" option in the Slowly Changing Dimension Type 2 (SCD2) transform.
To circumvent this:
- From the Downloads tab above, unzip and save the <Load_Time_Fix.spk> file to a known location, such as c:\temp.
- In SAS Data Integration Studio, select Import > SAS Package and import <Load_Time_Fix.spk> into /Products/Cross Industry Detail Data Store.
- Open and run the job <find_jobs_with_missing_load_time_column> from the /Products/Cross Industry Detail Data Store/Load Tim Column Fix folder.
- Open the job <Fix_Selected_Load_Time_Columns> from the /Products/Cross Industry Detail Data Store/Load Tim Column Fix folder. Open the Transformation properties, select the Options tab and select 'All'. Select 'OK' and Run the job.
Note: For a visual representation of the above steps, please download and unzip the <Load Time Column Fix Tool> document from the Downloads tab above.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows Vista | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| SAS System | SAS Human Capital Management | Microsoft® Windows® for x64 | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows Vista | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| SAS System | SAS Strategy Management | Microsoft® Windows® for x64 | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows Vista | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 5.1 | 5.1 | 9.2 TS2M2 | 9.2 TS2M3 | ||